create procedure [dbo].[BAEConfigurationGetAll] @category as
varchar(32)
AS
    IF(@category = '')
        BEGIN
            SELECT *
            FROM Configuration
            ORDER BY ConfigurationID;
        END
    ELSE
        BEGIN
            SELECT *
            FROM Configuration WHERE UPPER(Category) = UPPER(@category)
            ORDER BY ConfigurationID;
        END

GO